home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
SPREOTUS
/
123LEARN.LZH
/
WRKBK3.TXT
< prev
Wrap
Text File
|
1989-03-11
|
41KB
|
1,200 lines
Documentation for using the Lotus Learning Systems is contained in
the disk-based tutorial itself.
To start the tutorial follow the directions on the label of each
diskette. Additional information about how to start the tutorial
is contained in this file. Print it all out and read it carefully.
A workbook is available to use with the tutorial when you register
however, it is not necessary to have the workbook to use the tutorial.
THIS FILE is a brief look at the contents of the workbook that
is available when you register the program. It is not possible to
demonstrate in a text file the quality and professionalism used in
the workbook but you can get a feel for the content and what kind
of educational tool it is. The workbook is full of diagrams and
explanations for using Lotus 1-2-3. Questionnaires are included to
help you learn most effectively from the disk-based tutorial.
Some of the subjects covered in this file include:
Programmed-Computer Aided Learning
Keyboards
About this Program
How to Use the Course
Topic Covered in the Course
The Worksheet files you get as a registered user
The Menu Structure of the Tutorial (no graphics)
How to use DOS to copy and backup the diskettes
How to install the Lotus Learning System
Lotus 1-2-3 Glossary
Spreadsheet Questionnaire
Cell Addresses
The content of this file is an ASCII file saved from a desk-top
publishing program. As such the content is exactly as it is in the
workbook but it doesn't communication the laser printed, multi-font,
graphic presentation of the registered workbook. Also only the first
several pages of the workbook are included here.
The registered workbook is 130 pages long.
If you have any questions about the program please don't hesitate
to call (206)392-9654 ask for Jerry.
Registration information is in the disk-based tutorial. Use the DOS
print-screen to print the forms and other information about quantity
discounts for schools, etc...
Workbook
to accompany
The LOTUS LEARNING SYSTEM
Jerold L. Reed
1988
Third Edition
ECC Learning Systems
Bellevue, Washington
LICENSE AGREEMENT
You may use this software on any computer, as long as only one
person uses it at a time. If several people use the software at the
same time, you must pay one license fee for each additional
person. If you use the software on a computer network, you must
pay for as many licenses as the number of people who use the
software simultaneously.
This software is protected by international copyright laws. You may
copy it only for backup purposes. ECC Learning Systems is
licensing the software to you; it is not sold.
Neither you nor any reseller may rent, lease, sell licensed copies on
approval, or otherwise transfer the right to use this software to
another person, except that you may sell or give away your original
copy, as long as you do not keep any copies.
LIMITED WARRANTY
If you are dissatisfied with this software for any reason, you may
return it within 10 days to where you purchased it for a full refund.
If you have a defective diskette, follow the Warranty instructions in
this workbook.
ANY IMPLIED WARRANTIES INCLUDING ANY WARRANTIES OF
MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE
ARE LIMITED TO THE TERM OF THE EXPRESS WARRANTIES. ECC
LEARNING SYSTEMS SHALL NOT IN ANY CASE BE LIABLE FOR
SPECIAL, INCIDENTAL, CONSEQUENTIAL, INDIRECT OR OTHER
SIMILAR DAMAGES ARISING FROM ANY BREACH OF THESE
WARRANTIES EVEN IF ECC LEARNING SYSTEMS HAS BEEN
ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Some states
do not allow the exclusion or limitation of incidental or
consequential damages, so the above limitation or exclusion may
not apply to you. This Warranty gives you specific legal rights, and
you may also have other rights which vary from state to state. ECC
LEARNING SYSTEMS'S maximum liability shall not exceed the price
paid by the enduser/licensee.
The LOTUS LEARNING SYSTEM
PROGRAM Jerold L. Reed
DOCUMENTATION Jerold L. Reed
PRODUCT EDITING
AND TESTING Marta H. Reed
B Copyright 1987, 1988 by Jerold L. Reed. All rights reserved. No
part of this publication may be reproduced, displayed on a
computer system, transmitted, transcribed, stored in a retrieval
system, or translated into any language or computer language, in
any form or by any means, electronic, mechanical, magnetic,
optical, chemical, manual or otherwise, without the prior written
consent of Jerold L. Reed.
Disclaimer: Jerold L. Reed reserves the right to revise this
publication and to make changes from time to time in the content
hereof without obligation of Jerold L. Reed to notify any person of
such revision or changes. This workbook describes the use of The
LOTUS LEARNING SYSTEM, which may be different than other
similar programs. Subsequent versions of The LOTUS LEARNING
SYSTEM may be different than that described in this workbook.
Trademarks: The LOTUS LEARNING SYSTEM is a registered
trademark, P-CAL is a registered trademark, and
Programmed-Computer Aided Learning is a registered trademark, of
ECC LEARNING SYSTEMS. IBM and IBM Personal Computer are
registered trademarks, of International Business Machines
Corporation. Compaq is a registered trademark of Compaq
Computer Corporation. Lotus is a trademark of Lotus Development
Corp.
Printed in the United States of America.
P-CAL
\\\\\\\\\\\\
PROGRAMMED-
COMPUTER AIDED
LEARNINGA
____________________________________________________________
ECC Learning Systems offer an unique approach to learning
software application programs. P-CALA (Programmed-Computer
Aided LearningA) uses the elements of computer interaction,
workbook exercises, cognitive response, real look and feel
simulations, and guided direct experience to facilitate an effective
learning experience. This approach reduces the learning curve and
increases learning retention.
There are five other approaches used in teaching software
application programs. First, is the instructor led classroom
situation. Usually there are handouts, demonstrations and guided
direct experience incorporated in the classroom situation. Second,
is the textbook approach. A person purchases a book and works
independently to learn how to use the software application. Third,
is the video based training method. The student and follows the
instructions of the teacher on the tape while he uses the specific
application program on his computer. Fourth, is the tape recorder
and workbook technique. The student listens to a tape and follows
its instructions while practicing exercises relating to the application
program he is studying. Lastly, is the disk-based tutorial. This is a
computer program which provides information on the application
program the student wants to learn and allows him/her to practice
simulations of the program.
P-CALAtakes a combination approach of a disk-based tutorial,
workbook, and practice in the application program. This is
classified as PROGRAMMED because these elements are interactive
and directive. The workbook will direct the student to use the
disk-based tutorial, the disk-based tutorial will direct the student to
use the workbook, the workbook will guide the student while
he/she is using the application program, and the workbook and
disk-based tutorial are used simultaneously. All in all there is a high
degree of student participation while using several different types of
learning mediums. P-CALAtakes a distinctive educational approach
utilizing solid learning theory and practical learning experiences.
NOTES:
KEYBOARDS
\\\\\\\\\\\\\\\\\\\\\\\\\\
STYLES
____________________________________________________________
The basic layout of the computer keyboard includes the
typewriter keys, function keys and calculator/cursor keys. Alpha
and numeric keys both in lower and upper case occupy one section
of the keyboard. There is also a collection of keys that closely
resemble a 10-key pad normally found on a calculator, and another
special set of keys are labeled with F1 through F10...? A variety of
keyboards are available today, some with special cursor movement
keys, mouse pads, drawing pads, etc...
AT STYLE KEYBOARD
This style of keyboard is organized into three areas. The first area is
the basic typewriter section and is located in the center of the
keyboard. The second area is the 10-key pad located to the right of
the main typewriting section and is composed of number keys
which double as cursor movement keys. It also includes plus,
minus, multiply, and special symbol keys.
To the left of the typewriter section are the function keys. They are
numbered from F1 through F10.
ENHANCED STYLE KEYBOARD
This keyboard style expands the types and number of keys available
to the user. In addition to the three parts mentioned for the AT
style keyboard there is a special set of keys between the typewriter
and 10-key pad. These two groups of keys are for moving the
cursor exclusively. They allow the 10-key pad to be used for
number entry only.
Another difference between the two keyboards mentioned is that
the enhanced keyboard puts the function keys across the top of the
keyboard instead of down the left side as on the AT style keyboard.
Regardless of the location of the keys on the various keyboards,
they perform exactly the same tasks.
NOTES:
GETTING STARTED
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
ABOUT THIS PROGRAM
____________________________________________________________
Welcome to The LOTUS LEARNING SYSTEM. This program
is especially designed for the novice computer/spreadsheet user.
LLS (The LOTUS LEARNING SYSTEM) has been used extensively in
classroom and independent study situations. If you do not know
how to 'boot' your system, change your current drive, name files or
load a program, this workbook will provide help with these
maintenance tasks. This workbook describes how to get started,
the files on the diskettes, the menu structure of the disk-based
tutorial, and how to use the components of the total program. In
addition to these explanations, this workbook contains questions
and exercises which are used in conjunction with the disk-based
tutorial. Be sure to take the time to read this workbook up to
CELL ADDRESSES before starting up the disk-based tutorial.
LLS is organized into three components, a 500+ screen disk-based
tutorial, this workbook, and a Lotus 1-2-3 worksheet file
INTRO.WK1. The disk-based tutorial is loaded into the computer
by executing the command "Learn Lotus". A short series of screens
will introduce you to the topics covered, the conventions used in
the tutorial and an explanation of its menus. The tutorial is very
user friendly. At the bottom of each screen are options which you
can use to control the program. Specific function keys allow you to
backup a screen, go to a menu, skip over a practice session or
proceed with the course. When viewing a menu, the program
provides a brief explanation of topics covered by each menu option.
Below the menu is an explanation of which keys select a menu
option. During your studies in the disk-based tutorial you will be
directed to STOP and complete exercises in this workbook. This
workbook contains carefully selected questions to help you focus
on important facts about Lotus 1-2-3. The questions should be
answered as you proceed through the disk-based tutorial. The
exercises the disk-based tutorial directs you to complete, include a
brief explanation, an example, and answers for the exercise. As you
complete each exercise this workbook directs you to continue your
studies in the disk-based tutorial. After studying the disk-based
tutorial, answering the questions and completing the exercises, you
can load your Lotus 1-2-3 program and using the file INTRO.WK1
build two financial models. This last component is optional
depending on whether or not you have Lotus 1-2-3. The last
section of this workbook, building models, provides step-by-step
directions for using the Lotus file INTRO.WK1. The Lotus 1-2-3 file
INTRO.WK1 is an automated program which will guide you through
the model building process by itself so you may not need to use the
printed directions to build the financial models.
HOW TO USE THIS COURSE
Wouldn't it be tragically ironic to spend hours on this
program and yet fail to learn Lotus 1-2-3. Don't take shortcuts and
don't skip over material. Make the commitment right now to use
the disk-based tutorial as the basis for all your studies. Answer all
of the questions in the workbook. Complete the exercises when
directed to do so. Preview the lesson objectives, study the lesson,
review the lesson objectives, and determine whether or not you
should go over the lesson material again. Continue with the course
only when you have an understanding of a lesson that matches the
lesson objectives. If you follow this carefully designed program
you will become proficient in the features of Lotus 1-2-3.
TOPICS COVERED IN THE COURSE
S History and Background of Spreadsheets
S Applications of Lotus 1-2-3
S Overview of Lotus 1-2-3 Diskettes
S The Lotus 1-2-3 Access System
S The Control Panel
S The Keyboard and Lotus 1-2-3
S Plan and Design of Spreadsheets
S The Lotus 1-2-3 Menu Command Words
S Worksheet Command Word
S Range Command Word
S Copy Command Word
S Move Command Word
S File Command Word
S Print Command Word
S Graph Command Word
S System Command Word
S Quit Command Word
S Real look and feel simulations of Lotus 1-2-3
S Using the worksheet file INTRO.WK1
The LOTUS LEARNING SYSTEM DISKETTES
The program diskettes you received with this workbook
contain various files that you will use during your studies of Lotus
1-2-3. A listing of the files for each diskette and a brief description
of each file is provided for your information. To use the files simply
follow the instructions on the diskette labels and directions
contained in this workbook.
FILES ON DISKETTE #1:
S INTRO.WK1S GOSOFT.BAT
S GRAPHS.WK1S GOHARD.BAT
S PRTAXES.WK1S LEARN.EXE
S FAMBGT.WK1S GO.BAT
S AMORTIZE.WK1S FINISHED.TXT
S INSTALL.TXT
INTRO.WK1 is a worksheet file which contains the tutorial for
building the two financial models Trial Balance and Profit/Loss
statement. It is also an example of user defined menus and macro
driven applications.
GRAPHS.WK1 is a duplication of the graphs in the disk-based
tutorial. You can use this file to practice building graphs using Lotus
1-2-3 program.
PRTAXES.WK1 is designed to calculate payroll taxes. It is an
example of the Range-Input command.
FAMBGT.WK1 is a weekly family budget that calculates which bills
have to be paid during which week of the month. It is an
illustration of complex formulas and date functions.
AMORTIZE.WK1 is used for calculating mortgage payments with
the ability to vary the payments based on number of months,
percentage rate, and beginning balance. It is an example of
complex formulas and simple macros.
GOSOFT.BAT is the batch file that loads The LOTUS LEARNING
SYSTEM disk-based tutorial into the computer's memory when
using a double floppy drive system.
GOHARD.BAT is the batch file that loads The LOTUS LEARNING
SYSTEM disk-based tutorial onto the hard drive when using a hard
drive system. This will create a sub-directory on the hard drive and
copy all of the program files into that sub-directory.
GO.BAT is the batch file used to load The LOTUS LEARNING
SYSTEM disk-based tutorial into the computer's memory when
using the hard drive.
INSTALL.TXT will guide you through the installation process.
Simply follow the directions on the screen.
FINISHED.TXT is a text file that is part of the installation process.
All Lotus 1-2-3 WK1 files listed above, except INTRO.WK1, may
be copied and shared with your friends.
FILES ON DISKETTE #2:
S LOTUS.DBD S GOSOFT.BAT
S GO.BAT S GOHARD.BAT
S FINISHED.TXT
LOTUS.DBD is the disk-based tutorial file.
THE OTHER FILES ON THIS DISKETTE ARE THE SAME AS THOSE
DESCRIBED FOR DISKETTE 1.
GETTING AROUND THE TUTORIAL
The structure of the menus in any program is the primary
means you have to communicate with the program. This is true
with LLS also. There are three menus in the program, the ACCESS
MENU, the MAIN MENU and the COMMAND WORD MENU. The
ACCESS MENU contains three options, GETTING STARTED, MAIN
MENU and COMMAND WORD MENU. The program is designed
so that lesson material is presented in the proper order when the
option on the menus are selected from top to bottom. Therefore,
you should study GETTING STARTED first and MAIN MENU
second. The COMMAND WORD MENU is an option for review,
you should not select COMMAND WORD MENU from the
ACCESS MENU unless you have finished the entire course.
The MAIN MENU contains the bulk of the facts about Lotus 1-2-3.
The menu options should be selected from top to bottom starting
with Spreadsheet Background. The menu option, Lotus Menu
Structure, provides real look and feel practice sessions using actual
Lotus 1-2-3 commands. Each Lotus main menu command word is
explained and you are led through an actual application of that
command word. Don't worry... you can't make any mistakes! The
tutorial is designed so that you must learn how to use the
commands correctly the first time. If you touch the wrong key, the
computer beeps and allows you to type the correct key.
The menu option Trial Balance Model is an explanation of how to
use the worksheet file INTRO.WK1 to build the financial model Trial
Balance. The menu option Profit/Loss Model is an explanation of
how to use the worksheet file INTRO.WK1 to build the financial
model Profit/Loss. These should be the last two subjects you
complete in the disk-based tutorial.
Getting around the menus is easy. Observe the diagram below.
For example, to move from the COMMAND WORD MENU to the
MAIN MENU you simply put your highlighted cursor bar on the
option MAIN MENU and press <ENTER>. To get from the ACCESS
MENU to the MAIN MENU put the cursor bar on MAIN MENU and
press <ENTER>. If you are unclear about what keys to press on
any screen, look at the bottom of the screen and you will see the
possibilities listed there for you. Simply select the one you want to
use.
TUTORIAL MENU STRUCTURE
CONVENTIONS USED IN THE TUTORIAL
The computer screen is designed to help you be in control of
the tutorial. This is accomplished by providing you function keys
that will allow you to Go Back One Screen, Go To The Main Menu,
Skip a Practice Session or Go To The Next Screen. See the diagram
below for the illustration of the screen design:
SHORT CUT MENUS
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
____________________________________________________________
_______________________________________
There are two short cut menus at the beginning of the
tutorial. These will speed up your use of the tutorial AFTER your
initial use of the program.
TUTORIAL ACCESS MENU
This menu, illustrated below, is the first short cut menu you
will encounter in the disk-based tutorial. On this menu, in addition
to the choices at the bottom of all the screens, are the options F, C,
and R. Option F, For the first-time user, must be selected by
first-time users of the tutorial. This option takes you through a
series of screens which explain the conventions used in the tutorial
and the menu structure. Option C, For the continuing student, is
used after you have begun studying the workbook exercises. It
takes you to another short cut menu, QUICK ACCESS. The QUICK
ACCESS MENU allows you to re-start the tutorial from the last
completed subject. Option R, For the person who wants to review
the tutorial, takes you directly to the ACCESS MENU and allows
you to choose either the MAIN MENU or the COMMAND WORD
MENU. From these two menus you can select the specific subjects
you want to review.
QUICK ACCESS MENU
The QUICK ACCESS menu is selected by choosing option C
from the TUTORIAL ACCESS MENU. This is the menu you will use
when you re-load The LOTUS LEARNING SYSTEM to continue your
studies. On this menu, illustrated below, are the options Cell
Addresses, Cell Formulas, etc..., in addition to the choices at the
bottom of all the screens. When you select the ACCESS KEY
associated with a subject, you are indicating that you have
completed that subject and are ready to continue with the tutorial.
For example, when you select the ACCESS KEY, F2, associated with
Cell Addresses, the tutorial will begin your study session with Cell
Formulas, the next subject.
BACKUP DISKS
\\\\\\\\\\\\\\\\\\\\\\\\\\\\
____________________________________________________________
The following information is provided to assist you in
formatting and backing up your program disks. If you already know
how to format and backup disks you may wish to skip this section.
PREPARING DISKETTES: (Floppy System)
Format
You will need two blank diskettes.
NOTE: Formatting erases all files on a diskette.
Follow the steps below to format your diskettes. The words which
are enclosed within < > symbols refer to specific keys on the
computer keyboard, for example, <ENTER> refers to the ENTER
key on the keyboard. Words or letters, in bold, following the word
type, are to be typed from the keyboard, for example, you would
type FORMAT B: when you see FORMAT B: following the word
type.
1. Put DOS System diskette in
drive A and a blank
diskette in drive B.
2. At the A> prompt, type
FORMAT B:
and press
<ENTER>
3. When you see the message:
Insert new diskette in drive B:
Strike any key when ready_
Make sure you have the blank diskette in drive B: then tap
<ENTER>
If for some reason formatting does not begin, check to see that the
diskette is inserted with the label side up, and the "right protect"
notch is on the left side of the diskette. Also check to be sure the
disk drive door is closed. If either correction is made, tap
<ENTER>
If you cannot begin the format process with these
instructions, check with your DOS manuals.
4. As the disk is being formatted a message will appear on the
screen:
Formatting...
5. Wait until you get the message:
Format Complete.
362496 bytes total disk space
362496 bytes available on disk
Format Another (Y/N)?_
6. Remove the formatted diskette from drive B: and insert the other
blank diskette for formatting.
7. Press
<Y>
for yes, this tells DOS to format another diskette.
8. Repeat steps 3 through 5.
9. When formatting is complete press N for No, this tells DOS that
you are through formatting.
PREPARING DISKETTES: (Hard Drive System)
Format
You will need two blank diskettes.
NOTE: Formatting erases all files on a diskette.
Follow the steps below to format your diskettes.
1. Put a blank diskette in drive A
2. At the C> prompt, type
FORMAT A:
and press
<ENTER>
3. When you see the message:
Insert new diskette in drive A:
Strike any key when ready_
Make sure you have the blank diskette in drive A: then tap
<ENTER>
If for some reason formatting does not begin, check to see that the
diskette is inserted with the label side up, and the "right protect"
notch is on the left side of the diskette. Also check to be sure the
disk drive door is closed. If either correction is made, tap
<ENTER>
If you cannot begin the format process with these instructions,
check with your DOS manual.
4. As the disk is being formatted a message will appear on the
screen:
Formatting...
5. Wait until you get the message:
Format Complete.
362496 bytes total disk space
362496 bytes available on disk
Format Another (Y/N)?_
6. Remove the formatted diskette from drive A: and insert the other
blank diskette for formatting.
7. Press
<Y>
for yes, this tells DOS to format another diskette.
8. Repeat steps 3 through 5.
9. When formatting is complete answer N for No, this tells DOS
that you are through formatting.
COPYING DISKETTES: (Floppy and hard disk systems)
Copy A:*.* B:
Follow the steps below to copy The LOTUS LEARNING SYSTEM
program diskettes.
1. Insert The LOTUS LEARNING SYSTEM diskette #1 in drive A:.
2. Insert a formatted diskette in drive B:.
3. At the A> prompt type
Copy A:*.* B:
and press
<ENTER>
4. Wait until the message appears on the screen...
_ file(s) copied
A>_
5. Repeat this procedure for The LOTUS LEARNING SYSTEM
diskette #2.
NOTES:
START TUTORIAL
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
____________________________________________________________
HARD DISK INSTALLATION
If you have a hard disk and only one floppy drive you must
install The LOTUS LEARNING SYSTEM on your hard disk. If you
have a hard disk and two floppy drive you may run the tutorial from
the floppies or install the program on the hard disk and run it from
the hard disk.
You will need 1 megabyte of free space available on your
hard disk.
To install The LOTUS LEARNING SYSTEM on your hard disk,
turn on your computer and go through your normal start-up
procedure. When the DOS C> prompt appears do the following:
1. Insert The LOTUS LEARNING SYSTEM diskette #1 in
Drive A.
2. Type the command shown below. Where you see
<ENTER> after the command, you should press the Enter key.
A:GOHARD <ENTER>
3. Follow the directions you see on your screen. You will be
asked to change diskettes.
4. When the installation is complete you will be notified by a
message on your screen.
5. When you have the DOS C> prompt again on the screen,
type the command shown below.
CD\LOTUSTUT <ENTER>
6. This command will make the newly created directory
your current directory.
7. When you are in the LOTUSTUT sub-directory, type the
command shown below.
GO <ENTER>
8. A screen will appear for Dan Bricklin's DEMO program.
Respond to that screen by pressing the space bar.
<SPACE BAR>
9. Follow the instructions on the screen to use the tutorial.
FLOPPY DRIVE INSTALLATION (for 5¼" diskettes)
You must have two floppy drives if you want to run the
tutorial on floppies instead of the hard disk. To run The LOTUS
LEARNING SYSTEM on a two floppy system, turn on your computer
and go through your normal start-up procedure. At the DOS A>
prompt do the following:
1. Insert The LOTUS LEARNING SYSTEM diskette #1 in
Drive A, and #2 in Drive B.
2. Type the command shown below. Where you see
<ENTER> after the command, you should press
the Enter key.
GOSOFT <ENTER>
3. A screen will appear for Dan Bricklin's DEMO program.
Respond to that screen by pressing the space bar.
<SPACE BAR>
4. Follow the instructions you see on the screen to use the
tutorial.
FLOPPY DRIVE INSTALLATION (for 3½" diskettes)
You may have two floppy drives if you want to run the
tutorial on floppies instead of the hard disk. To run The LOTUS
LEARNING SYSTEM on a two floppy system, turn on your computer
and go through your normal start-up procedure. At the DOS A>
prompt do the following:
1. Insert The LOTUS LEARNING SYSTEM diskette in Drive A.
2. Type the command shown below. Where you see
<ENTER> after the command, you should press the Enter key.
LEARN LOTUS <ENTER>
3. A screen will appear for Dan Bricklin's DEMO program.
Respond to that screen by pressing the space bar.
<SPACE BAR>
4. Follow the instructions you see on the screen to use the
tutorial.
NOTE: If you have problems starting the
tutorial call the LLS Customer Support
line.
GLOSSARY
\\\\\\\\\\\\\\\\\\\\\\\
WORDS USED IN LOTUS 1-2-3
____________________________________________________________
ACCESS SYSTEM The menu that is loaded when you use the
command word, LOTUS, to execute the Lotus 1-2-3 program. It
provides a way to move from one Lotus 1-2-3 module to another.
ANCHOR CELL The first cell in a range of cell(s) upon which
various actions may be taken i.e. move, copy, print, etc...
ARGUMENT @FUNCTIONS or macros require arguments.
Arguments are a value or set of values used with an @FUNCTION
or macro which define what the impact will be on the worksheet.
CALC An indicator, located at the bottom of the worksheet screen,
which indicates that changes have been made to the worksheet
since the last manual recalculation. It is recommended that a
manual recalculation be performed prior to saving, print etc. the
worksheet.
COLUMN A column is a vertical block of cells in the worksheet
designated with an alphabetic letter.
COMMAND The name of a routine that performs a task in the
worksheet. Commands are accessed by pressing the </> slash
key on the keyboard. The main commands in Lotus 1-2-3 are
Worksheet, Range, Copy, Move, File, Print, Graph, Data, System
and Quit.
CRITERIA These are tests used in various database functions and
commands. Criteria is comprised of cell(s) whose contents define
or limit the actions of those functions or commands.
CURSOR The flashing underline or block on the screen which
identifies either the location where data may be entered or
highlights a command which can be executed.
DATABASE A range of cells organize in fields and records for the
purpose of sorting, extracting, manipulating, etc... simple data. It
can contain values or labels but cannot contain formulas, blanks, or
@functions.
DRIVER Normally refers to the program that properly coordinates
the Lotus 1-2-3 program and the printer you are using.
EDIT In this mode you can change the contents of a cell(s). It
might be used for spelling corrections, revising formulas, or erasing
the contents of the cell(s).
ERROR This message will flash in the upper right corner of the
screen to indicate that the program doesn't understand what it has
been requested to do, or is unable to figure out how to accomplish
it, given the current set of circumstances. A companion message
may appear in the lower left corner of the screen to clarify the what
the problem might be.
FORMULA Relationships established between cells which use
mathematical operators to calculate a result.
LABEL An entry placed in any cell that starts with an alphabetical
letter or a label-prefix character (*,^,').
LOGICAL This applies to a logical operator that you might use in a
formula to establish specific relationships. (=, <, >, <=, >=, (),
#NOT#, #AND#, #OR#, etc...).
MACRO A saved set of keystrokes that can be reused by pressing a
two-keystroke command sequence. The macro is used to automate
the processing of data, printing, graphing, etc... especially in a
worksheet that is used for repetitive tasks that require extensive
keystroking by the user.
MENU Primarily refers to the Lotus 1-2-3 menu that has a
multi-level structure. It can also refer to a multi-level structure of
command words which can be defined by a user during the
development of an application using the command language of
Lotus 1-2-3.
MODE This describes a state the program is in at any time during
its operation. For example, READY mode indicates that the user can
enter data or call up the Main Menu. The main modes in Lotus
1-2-3 are READY, FILE, WAIT, ERROR, CMD, etc.
NAMED RANGE A single cell or range of cells that are named using
the </>-Range-Name-Create command series. The primary
reason for naming a range is for ease in copying, moving, etc... the
desired cells.
PRECEDENCE The order in which Lotus 1-2-3 will execute the
various operators in a formula.
QUIT This command, depending on what level of the Lotus Menu
structure, will terminate the particular function. At the main menu,
and select the menu option Quit, you will have taken the first step
to terminating the Lotus 1-2-3 program.
ROW This is a horizontal block of cell(s) in a worksheet.
SPREADSHEET This refers to the blank collection of rows and
columns that you use to enter data or a program that contains
various functions, commands, and formulas for financial analysis
and modeling.
TITLES Row(s) or column(s) locked in place on the spreadsheet
while the rest of the spreadsheet can scroll left, left, right, up or
down. Titles can be locked, horizontally, vertically or both. Titles
also refers to the command to define information for display on a
graph.
VALUE This is a number. The number could also be the result of a
formula or @FUNCTION.
WORKSHEET 1-2-3's electronic representation of a financial
spreadsheet. The worksheet is divided into 256 columns and 8192
rows.
/X This represents the beginning syntax of the command language
associated with the use of macros.
QUESTIONNAIRE
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
SPREADSHEET
BACKGROUND
____________________________________________________________
_______________________________________
NOTE: This questionnaire is to be used while you
are studying the disk-based tutorial's menu option
SPREADSHEET BACKGROUND on the MAIN MENU.
Study the questions below and begin your study of
SPREADSHEET BACKGROUND in the disk-based tutorial. As you
study the disk-based tutorial answer the questions. Some of the
questions are multiple-choice while others are fill-in. If you did not
answer all the questions by the time you finished studying the
disk-based tutorial, go through it again.
Select the correct answer and write the appropriate letter or
response in the space provided.
______ 1.How many diskettes did you receive when you
purchased Lotus 1-2-3?
a. 4
b. 5
c. 6
d. 7
______ 2.List the names of the diskettes you received:
a.
_____________________________________________
b.
_____________________________________________
c.
_____________________________________________
d.
_____________________________________________
e.
_____________________________________________
f.
_____________________________________________
______ 3.The purpose of the Utility Disk is:
a. To keep track of your water and sewer bills
b. To provide mathematical functions for your
spreadsheet
c. To translate files to and from Lotus 1-2-3
d. None of the above
______ 4.The purpose of the Printgraph disk is:
a. To select fonts, graph size, resolution, and type of
printer
b. To mark and select the graph to print
c. To print the graph to the hard disk
d. Both a and b
______ 5.What kinds of graphs can you create with Lotus
1-2-3?
a. Large, medium and small graphs
b. Black/white and color graphs
c. Pie, line, bar, stacked bar, and XY
d. All of the above
______ 6.How can Lotus 1-2-3's database capabilities be
applied?
a. Mailing lists
b. Inventory control
c. Form printing
d. All of the above
______ 7.What is a macro?
a. A fish that lives in the Atlantic Ocean
b. A command language of Lotus 1-2-3
c. A collection of keystrokes that run when <Alt>
and another key are pressed at
the same time
d. Both b and c
CELL ADDRESSES
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
____________________________________________________________
_______________________________________
Be sure you have studied the section on cell addresses in the
disk-based tutorial before attempting to complete this exercise.
Lesson Goals
After completing this exercise, you will be able to:
1. Name the cell address of a cell at any intersection on the
spreadsheet.
2. Use a cell address to find a cell anywhere on the spreadsheet.
Introduction
This exercise provides an application of the concepts you
have studied in the tutorial. Recall that a cell address is defined as
the intersection of a column and row on a spreadsheet. To write a
cell address you first identify the column letter by looking up the
column to the top of the spreadsheet, second you identify the row
number by looking to the left edge of the spreadsheet. A cell
address is written with the column letter first, then the row number.
Exercise
In the exercise below, identify the cell address for each
shaded cell by writing the cell address at the right edge of the row,
containing the shaded cell. In the example below, the shaded area
on the left has the cell address B2, and the shaded area on the right
has the cell address E4.
Write the answers to the exercise in the blocks provided.
After completing the exercise turn the page to check your answers.
____________________________________________________________
_______________________________________
EXAMPLE:
____________________________________________________________
_______________________________________
EXERCISE:
ANSWERS TO EXERCISE ON CELL ADDRESSES
_________________________________________
The answers to the exercise on cell addresses, from top to bottom,
are:
ANSWER DESCRIPTION
D6The intersection between column D and row 6.
A7The intersection between column A and row 7.
F8The intersection between column F and row 8.
E9The intersection between column E and row 9.
B10The intersection between column B and row 10.
C11The intersection between column C and row 11.
D12The intersection between column D and row 12.
Check your answers with the diagram below:
____________________________________________________________
____________________________________________________________
REVIEW
When identifying a cell address first locate the cell you wish
to identify. Then look up to the column letter and left to the row
number. Write down the column letter first and then the row
number. An electronic spreadsheet has columns and rows. Each
column is assigned a letter from A to IV. Lotus 1-2-3 has a total of
254 columns. Each row is assigned a number from 1 to 8192.
Lotus 1-2-3 has a total of 2,000,000 cells at the intersections of
columns and rows which are identified by cell addresses.
RELATIVE REFERENCE
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
____________________________________________________________
Be sure you have studied the disk-based tutorial on relative cell
references before attempting to complete this exercise.
Lesson Goals
After completing this exercise, you will be able to:
1.Use a relative cell reference to import a value from another
cell to the current cell.
2.Copy a relative cell reference to obtain expected results.
3.Apply the general rule that Lotus 1-2-3 uses to locate the cell
referenced in the current cell.
Introduction